package DBLayer;

import java.util.ArrayList;

import ModelLayer.Contract;

public interface IFDBContract {
	public ArrayList<Contract> getAllContracts();
	public ArrayList<Contract> getAllActiveContracts();
	public ArrayList<Contract> getAllContracts_where(String wClause);
	public Contract getContract_byContractId(int contractId);
	public ArrayList<Contract> getContract_byApartmentId(int apartId);
	public Contract getContract_byTenantId(int pid);
	public Contract getContract_byTenantName(String tenantName);
	public ArrayList<Contract> getContract_byTenant_or_ByLandlord_Name(String name);
	
	public ArrayList<Contract> searchRandom(String searchF);
	public Contract getContract_byApartId(int apartId);
	
	
	public int insert(Contract contracts);
	public int update(Contract contracts, boolean updateCommissionSimilar);
	public int delete(int contractId);
	int getContractsExpiringThisMonth();
	int getContractsExpiringNextTwoMonths();
}
